E T Consultant - Analytics & Reporting
E T Consultant - Analytics & Reporting
Job #:
req28236
Organization:
IFC
Sector:
Other
Grade:
EC1
Term Duration:
1 year 0 months
Recruitment Type:
Local Recruitment
Location:
Washington, DC,United States
Required Language(s):
English
Preferred Language(s):
Closing Date:
7/30/2024 (MM/DD/YYYY) at 11:59pm UTC
Description
IFC - a member of the World Bank Group - is the largest global development institution focused on the private sector in emerging markets. We work in more than 100 countries, using our capital, expertise, and influence to create markets and opportunities. Our mission is to leverage the power of the private sector to end extreme poverty and boost shared prosperity on a livable planet.
The Vice Presidency for Corporate Support (COSVP) integrates Budget and Business Administration, Strategy, HR, Communication, and Information & Technology functions under one umbrella to enable the execution of IFC's management and operational needs in the best way. As part of the VPU, the Strategic Initiatives, Analytics & Knowledge Management (CSI) department exists to (1) drive innovation and continuous improvement within Corporate Support VPU and (2) together with all other functions within our VPU and in partnership with other relevant units across IFC, support the Management Team and the rest of our senior leadership in designing and implementing the institutional change needed to achieve IFC's strategic objectives and growth ambitions.
The Analytics & Reporting (CSIAR) unit serves as a center of excellence (CoE) for standardizing, streamlining, and automating BI/reporting and analytics for internal clients and the Board. In this capacity, the CSIAR unit partners very closely with individual business departments and teams for subject matter expertise and domain knowledge. It is additionally tasked with working hand in hand with IFC's Information Technology (CIT) department on technology, tools, and data platforms to adopt advanced and transformational analytics, including predictive and prescriptive analytics.
Duties and Accountabilities
The CSIAR unit is seeking a qualified candidate to support the overall BI/reporting and analytics work program, including the transition from descriptive to advanced and transformational analytics. The work program includes several components with the primary goal to simplify business processes, standardize and automate recurring reports for reliable analysis and deeper insights on IFC resources thus enabling data-driven decisions. This position will support various BI/Reporting and Analytics solutions in partnership with team members and client departments. This candidate will be expected to support and maintain an existing SQL Server data mart, coordinate the transition to IFC's future cloud data platform in Microsoft Azure, and deliver data modeling / data pipeline solutions in Microsoft's Power Platform / Fabric offerings.
Key tasks and responsibilities include:
• Gain a deep understanding of IFC's Operations, Knowledge Management, Human Resources, Budget & Administration, Partnerships and Trust Funds to understand business requirements and deliver innovative solutions
• Coordinate and maintain an existing SQL Server data mart, Alteryx workflows, and support the transition to IFC's future cloud-based data architecture in Microsoft Azure
• Coordinate business requirement gathering sessions and input to create and manage reporting solutions and modules in Power BI to address common business questions
• Create data models and implement data transformations using Power Query to enable advanced analytics to include leveraging Quick Insights, AI Insights, Text Analytics, NLQ and other machine learning techniques to extract insights from data
• Design and build interactive dashboards, reports, and visualizations using Power BI desktop
• Leverage data science toolsets (Python/R) to perform data analysis, statistical modeling, and create predictive/prescriptive BI/reports and analytics
• Collaborate with the client teams to identify opportunities for improving knowledge and data capture, organization, and dissemination.
• Propose and implement data-driven solutions to optimize data management processes and systems.
• Remain up to date on industry data and analytics trends including Generative AI, Machine Learning and predictive/prescriptive analytics offerings
• Communicate complex results to technical and non-technical audiences to enable decision-making
• Demonstrate strong interpersonal skills and desire to work in teams in fast-paced work environments
• Manage multiple concurrent projects that require inputs from stakeholders while balancing impact on business needs
• Collaborate effectively with IT for technology, tools, data engineering and platforms
• Ensure adherence to data governance policies, standards, and procedures
Selection Criteria
• 2 to 6 years of prior relevant work experience (reporting, analytics, data management) with preferred business process exposure to IFC operations, human resources, financial, budget & administration, trust funds business processes
• Bachelor's or Master's degree in Business Analytics, Statistics, Economics, Information Systems, Computer Science, Data Science, Business Administration or equivalent work experience
• Required working experience with SQL Server, Alteryx
• Required working experience with Power BI, DAX, and Power Query
• Required experience with programming languages such as SQL, Python, R
• Preferred experience with Microsoft Azure SQL/Synapse, Azure Data Factory, Microsoft Fabric
• Demonstrated ability to visualize data for effective storytelling
• Knowledge of statistical analysis, quantitative research and experience gathering and interpreting data.
• Demonstrated experience producing and maintaining schedules and communications
• Strong analytical and problem-solving skills with a high degree of initiative and creativity
• Prior experience working with cross-functional teams and across departments in a matrix organization
• High degree of adaptability to changing requirements and a dynamic environment
• Ability to work collaboratively in a fast-paced, internationally diverse work environment; strong interpersonal skills are essential
• Excellent communication and presentation skills
• Commitment to maintain the highest ethical standards
World Bank Group Core Competencies
We are proud to be an equal opportunity and inclusive employer with a dedicated and committed workforce, and do not discriminate based on gender, gender identity, religion, race, ethnicity, sexual orientation, or disability.
Learn more about working at the World Bank and IFC, including our values and inspiring stories.
Note: The selected candidate will be offered a one-year appointment, renewable at the discretion of the World Bank Group, and subject to a lifetime maximum ET appointment of three years. If an ET appointment ends before a full year, it is considered as a full year toward the lifetime maximum. Former and current ET staff who have completed all or any portion of their third-year ET appointment are not eligible for future ET appointments.
